Structured Spreadsheet Modeling and Implementation
نویسنده
چکیده
Developing an error-free spreadsheet has been a problem since the beginning of end-user computing. In this paper, we present a methodology that separates the modeling from the implementation. Using proven techniques from Information Systems and Software Engineering, we develop strict, but simple, rules governing the implementation from the model. The resulting spreadsheet should be easier to understand, audit and maintain. Index Terms — Spreadsheet modeling, Spreadsheet implementation, structured modeling.
منابع مشابه
Developing a Repeating Model Using the Structured Spreadsheet Modelling and Implementation Methodology
Spreadsheets often have variables and formulas that are similar, differing only by the fact that they refer to different instances of an entity. For example, the calculation of the sales revenues of the South and East regions are Revenues South = Price*Quantity Sold South and Revenues East =Price*Quantity Sold East. In this paper, we present a conceptual modelling approach that takes advantage ...
متن کاملStructured Spreadsheet Modelling and Implementation with Multiple Dimensions - Part 1: Modelling
Dimensions are an integral part of many models we use every day. Without thinking about it, we frequently use the time dimension: many financial and accounting spreadsheets have columns representing months or years. Representing a second dimension is often done by repeating blocs of formulas in a worksheet of creating multiple worksheets with the same structure.
متن کاملStructuring Modeling Knowledge for Collaborative Environments
We explore how a collection of models and related modeling knowledge could be made available over an organizational Intranet. The objective is to create an environment that will enable sharing and re-use of models and will promote collaborative work on models. Because of their widespread use in organizations, we will focus on spreadsheet models to illustrate our concepts. We begin by discussing...
متن کاملLearning from Expressive Modeling Task
This study aimed to present an authentic way of showing how computer assisted mathematical modeling of a real world situation helped to understand mystery of that situation. To achieve this aim, a group of pre-service mathematics teachers has been asked to think on how the trip computer of cars calculates the values like instant fuel consumption, average fuel consumption and the distance to be ...
متن کاملMODFLOW 2001 and Other Modeling Odysseys Proceedings, 2001, International Ground Water Modeling Center, Colorado School of Mines, Golden, CO, p. 815-822 The Power of Spreadsheet Models
Prior to using MODFLOW, students need experience with simpler codes that provide “hands-on” experience setting up boundary and initial conditions, coding simple solution algorithms, and handling numerical errors. The best way to do this is using spreadsheet models; faculty no longer can expect students to know a common computer language, but students are familiar with spreadsheets. Many aspects...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2015